package java.hilyb.dbtest.domain;

import java.util.Date;

/**
 * User: wlai
 * Date: 12/9/2014
 * Time: 13:45 PM
 */
public class Record {
    public static final String TABLE_NAME = "T_RECORD";
    public static final String C_ID = "ID";

    public static final String C_CATEGORY_ID = "C_ID";
    public static final String C_CONSUMED = "CONSUMED";
    public static final String C_TIME = "RECORD_TIME";
    public static final String C_MEMO = "MEMO";
    public static final String CREATE_TABLE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "("
            + C_ID + " integer primary key autoincrement,"
            + C_CONSUMED + " float not null,"
            + C_TIME + " integer not null,"
            + C_MEMO + " varchar(255),"
            + C_CATEGORY_ID + " integer not null)";
    private Integer id;
    private Integer categoryId;
    private String categoryName;
    private Float consumed;
    private Date recordTime;
    private String memo;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getCategoryId() {
        return categoryId;
    }

    public void setCategoryId(Integer categoryId) {
        this.categoryId = categoryId;
    }

    public String getCategoryName() {
        return categoryName;
    }

    public void setCategoryName(String categoryName) {
        this.categoryName = categoryName;
    }

    public Float getConsumed() {
        return consumed;
    }

    public void setConsumed(Float consumed) {
        this.consumed = consumed;
    }

    public Date getRecordTime() {
        return recordTime;
    }

    public void setRecordTime(Date recordTime) {
        this.recordTime = recordTime;
    }

    public String getMemo() {
        return memo;
    }

    public void setMemo(String memo) {
        this.memo = memo;
    }
}
